Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	63081
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.1 MiB
Average record size in memory	152.0 B

Variable types

Text	6
Categorical	5
Numeric	7

Alerts

`Clean Alternative Fuel Vehicle (CAFV) Eligibility` is highly overall correlated with `Electric Range` and 3 other fields	High correlation
`County` is highly overall correlated with `Legislative District` and 2 other fields	High correlation
`Electric Range` is highly overall correlated with `Clean Alternative Fuel Vehicle (CAFV) Eligibility` and 1 other fields	High correlation
`Electric Vehicle Type` is highly overall correlated with `Clean Alternative Fuel Vehicle (CAFV) Eligibility` and 3 other fields	High correlation
`Expected Price ($1k)` is highly overall correlated with `Clean Alternative Fuel Vehicle (CAFV) Eligibility` and 3 other fields	High correlation
`Legislative District` is highly overall correlated with `County`	High correlation
`Make` is highly overall correlated with `Clean Alternative Fuel Vehicle (CAFV) Eligibility` and 2 other fields	High correlation
`Model Year` is highly overall correlated with `Expected Price ($1k)`	High correlation
`State` is highly overall correlated with `County` and 1 other fields	High correlation
`ZIP Code` is highly overall correlated with `County` and 1 other fields	High correlation
`State` is highly imbalanced (99.9%)	Imbalance
`ZIP Code` is highly skewed (γ1 = -23.35409993)	Skewed
`ID` has unique values	Unique
`DOL Vehicle ID` has unique values	Unique
`Electric Range` has 14657 (23.2%) zeros	Zeros
`Base MSRP` has 60053 (95.2%) zeros	Zeros

Reproduction

Analysis started	2024-12-02 14:41:52.835105
Analysis finished	2024-12-02 14:42:58.664054
Duration	1 minute and 5.83 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

ID
Text

UNIQUE

Distinct	63081
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Length

Max length	7
Median length	7
Mean length	6.8818345
Min length	3

Characters and Unicode

Total characters	434113
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	63081 ?
Unique (%)	100.0%

Sample

1st row	EV33174
2nd row	EV40247
3rd row	EV12248
4th row	EV55713
5th row	EV28799

Value	Count	Frequency (%)
ev33174	1	< 0.1%
ev61786	1	< 0.1%
ev60210	1	< 0.1%
ev84036	1	< 0.1%
ev52059	1	< 0.1%
ev12248	1	< 0.1%
ev55713	1	< 0.1%
ev28799	1	< 0.1%
ev49859	1	< 0.1%
ev53121	1	< 0.1%
Other values (63071)	63071	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
E	63081	14.5%
V	63081	14.5%
1	32648	7.5%
4	32078	7.4%
2	32058	7.4%
8	32018	7.4%
3	32011	7.4%
7	31937	7.4%
5	31894	7.3%
6	31843	7.3%
Other values (2)	51464	11.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	434113	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	63081	14.5%
V	63081	14.5%
1	32648	7.5%
4	32078	7.4%
2	32058	7.4%
8	32018	7.4%
3	32011	7.4%
7	31937	7.4%
5	31894	7.3%
6	31843	7.3%
Other values (2)	51464	11.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	434113	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	63081	14.5%
V	63081	14.5%
1	32648	7.5%
4	32078	7.4%
2	32058	7.4%
8	32018	7.4%
3	32011	7.4%
7	31937	7.4%
5	31894	7.3%
6	31843	7.3%
Other values (2)	51464	11.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	434113	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	63081	14.5%
V	63081	14.5%
1	32648	7.5%
4	32078	7.4%
2	32058	7.4%
8	32018	7.4%
3	32011	7.4%
7	31937	7.4%
5	31894	7.3%
6	31843	7.3%
Other values (2)	51464	11.9%

VIN (1-10)
Text

Distinct	5592
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	630810
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1260 ?
Unique (%)	2.0%

Sample

1st row	5YJ3E1EC6L
2nd row	JN1AZ0CP8B
3rd row	WBY1Z2C56F
4th row	1G1RD6E44D
5th row	1G1FY6S05K

Value	Count	Frequency (%)
5yjygdee9m	334	0.5%
5yjygdee8m	331	0.5%
5yjygdee0m	325	0.5%
5yjygdee6m	318	0.5%
5yjygdee2m	311	0.5%
5yjygdee4m	300	0.5%
5yjygdee7m	298	0.5%
5yjygdeexm	297	0.5%
5yjygdee5m	286	0.5%
5yjygdee1m	285	0.5%
Other values (5582)	59996	95.1%

Most occurring characters

Value	Count	Frequency (%)
1	55974	8.9%
E	54714	8.7%
J	42662	6.8%
5	38820	6.2%
Y	37393	5.9%
A	31500	5.0%
3	27859	4.4%
C	26256	4.2%
D	21759	3.4%
G	21377	3.4%
Other values (23)	272496	43.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	630810	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	55974	8.9%
E	54714	8.7%
J	42662	6.8%
5	38820	6.2%
Y	37393	5.9%
A	31500	5.0%
3	27859	4.4%
C	26256	4.2%
D	21759	3.4%
G	21377	3.4%
Other values (23)	272496	43.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	630810	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	55974	8.9%
E	54714	8.7%
J	42662	6.8%
5	38820	6.2%
Y	37393	5.9%
A	31500	5.0%
3	27859	4.4%
C	26256	4.2%
D	21759	3.4%
G	21377	3.4%
Other values (23)	272496	43.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	630810	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	55974	8.9%
E	54714	8.7%
J	42662	6.8%
5	38820	6.2%
Y	37393	5.9%
A	31500	5.0%
3	27859	4.4%
C	26256	4.2%
D	21759	3.4%
G	21377	3.4%
Other values (23)	272496	43.2%

County
Categorical

HIGH CORRELATION

Distinct	41
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

King	33121
Snohomish	6908
Pierce	4822
Clark	3762
Thurston	2436
Other values (36)	12032

Length

Max length	12
Median length	4
Mean length	5.4326025
Min length	4

Characters and Unicode

Total characters	342694
Distinct characters	42
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Snohomish
2nd row	Skagit
3rd row	Pierce
4th row	King
5th row	Pierce

Common Values

Value	Count	Frequency (%)
King	33121	52.5%
Snohomish	6908	11.0%
Pierce	4822	7.6%
Clark	3762	6.0%
Thurston	2436	3.9%
Kitsap	2291	3.6%
Whatcom	1713	2.7%
Spokane	1487	2.4%
Benton	811	1.3%
Island	766	1.2%
Other values (31)	4964	7.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
king	33121	51.9%
snohomish	6908	10.8%
pierce	4822	7.6%
clark	3762	5.9%
thurston	2436	3.8%
kitsap	2291	3.6%
whatcom	1713	2.7%
spokane	1487	2.3%
benton	811	1.3%
island	766	1.2%
Other values (34)	5643	8.9%

Most occurring characters

Value	Count	Frequency (%)
i	49842	14.5%
n	49309	14.4%
K	35720	10.4%
g	34090	9.9%
o	21825	6.4%
h	18461	5.4%
a	15200	4.4%
s	14092	4.1%
e	13584	4.0%
r	12545	3.7%
Other values (32)	78026	22.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	342694	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	49842	14.5%
n	49309	14.4%
K	35720	10.4%
g	34090	9.9%
o	21825	6.4%
h	18461	5.4%
a	15200	4.4%
s	14092	4.1%
e	13584	4.0%
r	12545	3.7%
Other values (32)	78026	22.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	342694	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	49842	14.5%
n	49309	14.4%
K	35720	10.4%
g	34090	9.9%
o	21825	6.4%
h	18461	5.4%
a	15200	4.4%
s	14092	4.1%
e	13584	4.0%
r	12545	3.7%
Other values (32)	78026	22.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	342694	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	49842	14.5%
n	49309	14.4%
K	35720	10.4%
g	34090	9.9%
o	21825	6.4%
h	18461	5.4%
a	15200	4.4%
s	14092	4.1%
e	13584	4.0%
r	12545	3.7%
Other values (32)	78026	22.8%

City
Text

Distinct	398
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Length

Max length	24
Median length	17
Mean length	8.2492034
Min length	3

Characters and Unicode

Total characters	520368
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	62 ?
Unique (%)	0.1%

Sample

1st row	LYNNWOOD
2nd row	BELLINGHAM
3rd row	TACOMA
4th row	REDMOND
5th row	PUYALLUP

Value	Count	Frequency (%)
seattle	11463	15.7%
bellevue	3353	4.6%
redmond	2448	3.4%
vancouver	2301	3.2%
kirkland	2086	2.9%
island	2072	2.8%
sammamish	1874	2.6%
bothell	1769	2.4%
olympia	1545	2.1%
renton	1512	2.1%
Other values (419)	42557	58.3%

Most occurring characters

Value	Count	Frequency (%)
E	74900	14.4%
A	51412	9.9%
L	49545	9.5%
T	39353	7.6%
N	35373	6.8%
O	32778	6.3%
S	31962	6.1%
R	27384	5.3%
I	23427	4.5%
M	20829	4.0%
Other values (17)	133405	25.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	520368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	74900	14.4%
A	51412	9.9%
L	49545	9.5%
T	39353	7.6%
N	35373	6.8%
O	32778	6.3%
S	31962	6.1%
R	27384	5.3%
I	23427	4.5%
M	20829	4.0%
Other values (17)	133405	25.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	520368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	74900	14.4%
A	51412	9.9%
L	49545	9.5%
T	39353	7.6%
N	35373	6.8%
O	32778	6.3%
S	31962	6.1%
R	27384	5.3%
I	23427	4.5%
M	20829	4.0%
Other values (17)	133405	25.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	520368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	74900	14.4%
A	51412	9.9%
L	49545	9.5%
T	39353	7.6%
N	35373	6.8%
O	32778	6.3%
S	31962	6.1%
R	27384	5.3%
I	23427	4.5%
M	20829	4.0%
Other values (17)	133405	25.6%

State
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

WA	63076
OR	4
MT	1

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	126162
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	WA
2nd row	WA
3rd row	WA
4th row	WA
5th row	WA

Common Values

Value	Count	Frequency (%)
WA	63076	> 99.9%
OR	4	< 0.1%
MT	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wa	63076	> 99.9%
or	4	< 0.1%
mt	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
W	63076	50.0%
A	63076	50.0%
O	4	< 0.1%
R	4	< 0.1%
M	1	< 0.1%
T	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	126162	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
W	63076	50.0%
A	63076	50.0%
O	4	< 0.1%
R	4	< 0.1%
M	1	< 0.1%
T	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	126162	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
W	63076	50.0%
A	63076	50.0%
O	4	< 0.1%
R	4	< 0.1%
M	1	< 0.1%
T	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	126162	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
W	63076	50.0%
A	63076	50.0%
O	4	< 0.1%
R	4	< 0.1%
M	1	< 0.1%
T	1	< 0.1%

ZIP Code
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	501
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98252.382

Minimum	59937
Maximum	99403
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	985.6 KiB

Quantile statistics

Minimum	59937
5-th percentile	98006
Q1	98052
median	98119
Q3	98368
95-th percentile	98837
Maximum	99403
Range	39466
Interquartile range (IQR)	316

Descriptive statistics

Standard deviation	330.7156
Coefficient of variation (CV)	0.0033659805
Kurtosis	2857.4132
Mean	98252.382
Median Absolute Deviation (MAD)	98
Skewness	-23.3541
Sum	6.1978585 × 10⁹
Variance	109372.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98052	1710	2.7%
98033	1223	1.9%
98004	1140	1.8%
98115	1104	1.8%
98012	1019	1.6%
98006	1006	1.6%
98040	975	1.5%
98074	933	1.5%
98103	896	1.4%
98034	862	1.4%
Other values (491)	52213	82.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
59937	1	< 0.1%
97132	1	< 0.1%
97202	1	< 0.1%
97239	1	< 0.1%
97436	1	< 0.1%
98001	258	0.4%
98002	97	0.2%
98003	163	0.3%
98004	1140	1.8%
98005	495	0.8%

Value	Count	Frequency (%)
99403	25	< 0.1%
99402	6	< 0.1%
99362	2	< 0.1%
99361	1	< 0.1%
99357	7	< 0.1%
99356	2	< 0.1%
99354	126	0.2%
99353	86	0.1%
99352	218	0.3%
99350	20	< 0.1%

Model Year
Real number (ℝ)

HIGH CORRELATION

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2018.1871

Minimum	1993
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	985.6 KiB

Quantile statistics

Minimum	1993
5-th percentile	2013
Q1	2017
median	2018
Q3	2021
95-th percentile	2022
Maximum	2022
Range	29
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.7251924
Coefficient of variation (CV)	0.001350317
Kurtosis	-0.03658288
Mean	2018.1871
Median Absolute Deviation (MAD)	2
Skewness	-0.67921201
Sum	1.2730926 × 10⁸
Variance	7.4266734
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
2021	12922	20.5%
2018	9574	15.2%
2020	7363	11.7%
2019	7248	11.5%
2017	6699	10.6%
2016	4317	6.8%
2022	3819	6.1%
2015	3428	5.4%
2013	3289	5.2%
2014	2593	4.1%
Other values (9)	1829	2.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1993	1	< 0.1%
1998	1	< 0.1%
1999	2	< 0.1%
2000	4	< 0.1%
2002	2	< 0.1%
2008	14	< 0.1%
2010	14	< 0.1%
2011	594	0.9%
2012	1197	1.9%
2013	3289	5.2%

Value	Count	Frequency (%)
2022	3819	6.1%
2021	12922	20.5%
2020	7363	11.7%
2019	7248	11.5%
2018	9574	15.2%
2017	6699	10.6%
2016	4317	6.8%
2015	3428	5.4%
2014	2593	4.1%
2013	3289	5.2%

Make
Categorical

HIGH CORRELATION

Distinct	34
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

TESLA	27398
NISSAN	8548
CHEVROLET	6494
FORD	3752
KIA	3005
Other values (29)	13884

Length

Max length	20
Median length	14
Mean length	5.5760847
Min length	3

Characters and Unicode

Total characters	351745
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	TESLA
2nd row	NISSAN
3rd row	BMW
4th row	CHEVROLET
5th row	CHEVROLET

Common Values

Value	Count	Frequency (%)
TESLA	27398	43.4%
NISSAN	8548	13.6%
CHEVROLET	6494	10.3%
FORD	3752	5.9%
KIA	3005	4.8%
BMW	2649	4.2%
TOYOTA	2633	4.2%
AUDI	1236	2.0%
VOLKSWAGEN	1183	1.9%
CHRYSLER	1069	1.7%
Other values (24)	5114	8.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tesla	27398	43.4%
nissan	8548	13.5%
chevrolet	6494	10.3%
ford	3752	5.9%
kia	3005	4.8%
bmw	2649	4.2%
toyota	2633	4.2%
audi	1236	2.0%
volkswagen	1183	1.9%
chrysler	1069	1.7%
Other values (29)	5146	8.2%

Most occurring characters

Value	Count	Frequency (%)
S	48580	13.8%
A	46791	13.3%
E	45112	12.8%
T	40434	11.5%
L	37264	10.6%
N	20378	5.8%
O	19270	5.5%
I	16102	4.6%
R	13695	3.9%
H	9776	2.8%
Other values (17)	54343	15.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	351745	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	48580	13.8%
A	46791	13.3%
E	45112	12.8%
T	40434	11.5%
L	37264	10.6%
N	20378	5.8%
O	19270	5.5%
I	16102	4.6%
R	13695	3.9%
H	9776	2.8%
Other values (17)	54343	15.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	351745	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	48580	13.8%
A	46791	13.3%
E	45112	12.8%
T	40434	11.5%
L	37264	10.6%
N	20378	5.8%
O	19270	5.5%
I	16102	4.6%
R	13695	3.9%
H	9776	2.8%
Other values (17)	54343	15.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	351745	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	48580	13.8%
A	46791	13.3%
E	45112	12.8%
T	40434	11.5%
L	37264	10.6%
N	20378	5.8%
O	19270	5.5%
I	16102	4.6%
R	13695	3.9%
H	9776	2.8%
Other values (17)	54343	15.4%

Model
Text

Distinct	107
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Length

Max length	24
Median length	7
Mean length	6.2682107
Min length	2

Characters and Unicode

Total characters	395405
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	MODEL 3
2nd row	LEAF
3rd row	I3
4th row	VOLT
5th row	BOLT EV

Value	Count	Frequency (%)
model	27364	27.7%
3	12889	13.1%
leaf	8548	8.7%
y	7483	7.6%
s	4629	4.7%
volt	3326	3.4%
ev	3159	3.2%
bolt	2984	3.0%
x	2363	2.4%
niro	2304	2.3%
Other values (97)	23613	23.9%

Most occurring characters

Value	Count	Frequency (%)
L	46619	11.8%
E	46328	11.7%
O	41566	10.5%
	35581	9.0%
M	31192	7.9%
D	29385	7.4%
A	17845	4.5%
3	15315	3.9%
I	15150	3.8%
F	12681	3.2%
Other values (28)	103743	26.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	395405	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
L	46619	11.8%
E	46328	11.7%
O	41566	10.5%
	35581	9.0%
M	31192	7.9%
D	29385	7.4%
A	17845	4.5%
3	15315	3.9%
I	15150	3.8%
F	12681	3.2%
Other values (28)	103743	26.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	395405	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
L	46619	11.8%
E	46328	11.7%
O	41566	10.5%
	35581	9.0%
M	31192	7.9%
D	29385	7.4%
A	17845	4.5%
3	15315	3.9%
I	15150	3.8%
F	12681	3.2%
Other values (28)	103743	26.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	395405	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
L	46619	11.8%
E	46328	11.7%
O	41566	10.5%
	35581	9.0%
M	31192	7.9%
D	29385	7.4%
A	17845	4.5%
3	15315	3.9%
I	15150	3.8%
F	12681	3.2%
Other values (28)	103743	26.2%

Electric Vehicle Type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Battery Electric Vehicle (BEV)	47001
Plug-in Hybrid Electric Vehicle (PHEV)	16080

Length

Max length	38
Median length	30
Mean length	32.039283
Min length	30

Characters and Unicode

Total characters	2021070
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Battery Electric Vehicle (BEV)
2nd row	Battery Electric Vehicle (BEV)
3rd row	Battery Electric Vehicle (BEV)
4th row	Plug-in Hybrid Electric Vehicle (PHEV)
5th row	Battery Electric Vehicle (BEV)

Common Values

Value	Count	Frequency (%)
Battery Electric Vehicle (BEV)	47001	74.5%
Plug-in Hybrid Electric Vehicle (PHEV)	16080	25.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
electric	63081	23.5%
vehicle	63081	23.5%
battery	47001	17.5%
bev	47001	17.5%
plug-in	16080	6.0%
hybrid	16080	6.0%
phev	16080	6.0%

Most occurring characters

Value	Count	Frequency (%)
e	236244	11.7%
	205323	10.2%
c	189243	9.4%
i	158322	7.8%
t	157083	7.8%
l	142242	7.0%
V	126162	6.2%
r	126162	6.2%
E	126162	6.2%
B	94002	4.7%
Other values (13)	460125	22.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2021070	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	236244	11.7%
	205323	10.2%
c	189243	9.4%
i	158322	7.8%
t	157083	7.8%
l	142242	7.0%
V	126162	6.2%
r	126162	6.2%
E	126162	6.2%
B	94002	4.7%
Other values (13)	460125	22.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2021070	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	236244	11.7%
	205323	10.2%
c	189243	9.4%
i	158322	7.8%
t	157083	7.8%
l	142242	7.0%
V	126162	6.2%
r	126162	6.2%
E	126162	6.2%
B	94002	4.7%
Other values (13)	460125	22.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2021070	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	236244	11.7%
	205323	10.2%
c	189243	9.4%
i	158322	7.8%
t	157083	7.8%
l	142242	7.0%
V	126162	6.2%
r	126162	6.2%
E	126162	6.2%
B	94002	4.7%
Other values (13)	460125	22.8%

Clean Alternative Fuel Vehicle (CAFV) Eligibility
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Clean Alternative Fuel Vehicle Eligible	39172
Eligibility unknown as battery range has not been researched	14657
Not eligible due to low battery range	9252

Length

Max length	60
Median length	39
Mean length	43.586056
Min length	37

Characters and Unicode

Total characters	2749452
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Clean Alternative Fuel Vehicle Eligible
2nd row	Clean Alternative Fuel Vehicle Eligible
3rd row	Clean Alternative Fuel Vehicle Eligible
4th row	Clean Alternative Fuel Vehicle Eligible
5th row	Clean Alternative Fuel Vehicle Eligible

Common Values

Value	Count	Frequency (%)
Clean Alternative Fuel Vehicle Eligible	39172	62.1%
Eligibility unknown as battery range has not been researched	14657	23.2%
Not eligible due to low battery range	9252	14.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
eligible	48424	12.3%
clean	39172	10.0%
alternative	39172	10.0%
fuel	39172	10.0%
vehicle	39172	10.0%
not	23909	6.1%
range	23909	6.1%
battery	23909	6.1%
as	14657	3.7%
unknown	14657	3.7%
Other values (7)	86384	22.0%

Most occurring characters

Value	Count	Frequency (%)
e	423063	15.4%
	329456	12.0%
l	292102	10.6%
i	233820	8.5%
n	175538	6.4%
t	173980	6.3%
a	170133	6.2%
r	116304	4.2%
b	101647	3.7%
g	86990	3.2%
Other values (16)	646419	23.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2749452	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	423063	15.4%
	329456	12.0%
l	292102	10.6%
i	233820	8.5%
n	175538	6.4%
t	173980	6.3%
a	170133	6.2%
r	116304	4.2%
b	101647	3.7%
g	86990	3.2%
Other values (16)	646419	23.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2749452	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	423063	15.4%
	329456	12.0%
l	292102	10.6%
i	233820	8.5%
n	175538	6.4%
t	173980	6.3%
a	170133	6.2%
r	116304	4.2%
b	101647	3.7%
g	86990	3.2%
Other values (16)	646419	23.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2749452	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	423063	15.4%
	329456	12.0%
l	292102	10.6%
i	233820	8.5%
n	175538	6.4%
t	173980	6.3%
a	170133	6.2%
r	116304	4.2%
b	101647	3.7%
g	86990	3.2%
Other values (16)	646419	23.5%

Electric Range
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	98
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	107.08857

Minimum	0
Maximum	337
Zeros	14657
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	985.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	14
median	73
Q3	215
95-th percentile	291
Maximum	337
Range	337
Interquartile range (IQR)	201

Descriptive statistics

Standard deviation	104.11183
Coefficient of variation (CV)	0.972203
Kurtosis	-1.2767665
Mean	107.08857
Median Absolute Deviation (MAD)	73
Skewness	0.50763383
Sum	6755254
Variance	10839.273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14657	23.2%
215	4273	6.8%
84	2792	4.4%
220	2776	4.4%
238	2498	4.0%
208	1818	2.9%
19	1766	2.8%
25	1758	2.8%
53	1657	2.6%
291	1631	2.6%
Other values (88)	27455	43.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14657	23.2%
6	647	1.0%
8	25	< 0.1%
9	11	< 0.1%
10	95	0.2%
11	3	< 0.1%
12	98	0.2%
13	232	0.4%
14	780	1.2%
15	48	0.1%

Value	Count	Frequency (%)
337	40	0.1%
330	207	0.3%
322	1066	1.7%
308	337	0.5%
293	297	0.5%
291	1631	2.6%
289	432	0.7%
270	162	0.3%
266	1026	1.6%
265	104	0.2%

Base MSRP
Real number (ℝ)

ZEROS

Distinct	37
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2529.5239

Minimum	0
Maximum	845000
Zeros	60053
Zeros (%)	95.2%
Negative	0
Negative (%)	0.0%
Memory size	985.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	845000
Range	845000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12431.057
Coefficient of variation (CV)	4.9143861
Kurtosis	360.599
Mean	2529.5239
Median Absolute Deviation (MAD)	0
Skewness	9.6182968
Sum	1.595649 × 10⁸
Variance	1.5453118 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	60053	95.2%
69900	1048	1.7%
34600	346	0.5%
31950	298	0.5%
28500	143	0.2%
52900	141	0.2%
38500	124	0.2%
32250	112	0.2%
59900	104	0.2%
54950	99	0.2%
Other values (27)	613	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	60053	95.2%
28500	143	0.2%
31950	298	0.5%
32000	1	< 0.1%
32250	112	0.2%
32995	1	< 0.1%
33950	61	0.1%
34600	346	0.5%
34995	32	0.1%
35390	9	< 0.1%

Value	Count	Frequency (%)
845000	1	< 0.1%
184400	9	< 0.1%
110950	14	< 0.1%
109000	6	< 0.1%
102000	10	< 0.1%
98950	14	< 0.1%
91250	1	< 0.1%
90700	11	< 0.1%
89100	5	< 0.1%
81100	11	< 0.1%

Legislative District
Real number (ℝ)

HIGH CORRELATION

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.060383

Minimum	0
Maximum	49
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	985.6 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	20
median	34
Q3	43
95-th percentile	48
Maximum	49
Range	49
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	14.665353
Coefficient of variation (CV)	0.48786316
Kurtosis	-0.94103506
Mean	30.060383
Median Absolute Deviation (MAD)	11
Skewness	-0.56756768
Sum	1896239
Variance	215.07259
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41	4290	6.8%
45	4159	6.6%
48	3783	6.0%
46	2781	4.4%
36	2753	4.4%
43	2623	4.2%
1	2605	4.1%
5	2604	4.1%
37	2090	3.3%
34	2039	3.2%
Other values (40)	33354	52.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	< 0.1%
1	2605	4.1%
2	702	1.1%
3	340	0.5%
4	389	0.6%
5	2604	4.1%
6	580	0.9%
7	256	0.4%
8	696	1.1%
9	337	0.5%

Value	Count	Frequency (%)
49	929	1.5%
48	3783	6.0%
47	976	1.5%
46	2781	4.4%
45	4159	6.6%
44	1467	2.3%
43	2623	4.2%
42	984	1.6%
41	4290	6.8%
40	1558	2.5%

DOL Vehicle ID
Real number (ℝ)

UNIQUE

Distinct	63081
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9737376 × 10⁸

Minimum	4385
Maximum	4.7893457 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	985.6 KiB

Quantile statistics

Minimum	4385
5-th percentile	9145062
Q1	1.3733115 × 10⁸
median	1.7540033 × 10⁸
Q3	2.3003745 × 10⁸
95-th percentile	4.7537746 × 10⁸
Maximum	4.7893457 × 10⁸
Range	4.7893019 × 10⁸
Interquartile range (IQR)	92706306

Descriptive statistics

Standard deviation	1.0705463 × 10⁸
Coefficient of variation (CV)	0.54239544
Kurtosis	1.3220455
Mean	1.9737376 × 10⁸
Median Absolute Deviation (MAD)	42382991
Skewness	1.1053377
Sum	1.2450534 × 10¹³
Variance	1.1460693 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
109821694	1	< 0.1%
157568064	1	< 0.1%
103258753	1	< 0.1%
109824718	1	< 0.1%
184570816	1	< 0.1%
214459493	1	< 0.1%
175294542	1	< 0.1%
170242831	1	< 0.1%
192640311	1	< 0.1%
186886038	1	< 0.1%
Other values (63071)	63071	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4385	1	< 0.1%
4777	1	< 0.1%
10286	1	< 0.1%
10734	1	< 0.1%
12050	1	< 0.1%
23145	1	< 0.1%
27702	1	< 0.1%
35325	1	< 0.1%
46112	1	< 0.1%
61092	1	< 0.1%

Value	Count	Frequency (%)
478934571	1	< 0.1%
478926346	1	< 0.1%
478925947	1	< 0.1%
478925163	1	< 0.1%
478924358	1	< 0.1%
478916028	1	< 0.1%
478910428	1	< 0.1%
478909938	1	< 0.1%
478909224	1	< 0.1%
478909070	1	< 0.1%

Vehicle Location
Text

Distinct	499
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Length

Max length	29
Median length	29
Mean length	28.83862
Min length	21

Characters and Unicode

Total characters	1819169
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	65 ?
Unique (%)	0.1%

Sample

1st row	POINT (-122.287614 47.83874)
2nd row	POINT (-122.414936 48.709388)
3rd row	POINT (-122.396286 47.293138)
4th row	POINT (-122.024951 47.670286)
5th row	POINT (-122.321062 47.103797)

Value	Count	Frequency (%)
point	63081	33.3%
47.678465	1710	0.9%
122.122018	1710	0.9%
122.188994	1223	0.6%
47.678406	1223	0.6%
122.132064	1200	0.6%
122.203169	1140	0.6%
47.619011	1140	0.6%
122.297534	1104	0.6%
47.685291	1104	0.6%
Other values (988)	114608	60.6%

Most occurring characters

Value	Count	Frequency (%)
2	190214	10.5%
1	152695	8.4%
4	146798	8.1%
.	126162	6.9%
	126162	6.9%
7	118192	6.5%
6	87604	4.8%
3	82331	4.5%
8	75631	4.2%
5	75327	4.1%
Other values (10)	638053	35.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1819169	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	190214	10.5%
1	152695	8.4%
4	146798	8.1%
.	126162	6.9%
	126162	6.9%
7	118192	6.5%
6	87604	4.8%
3	82331	4.5%
8	75631	4.2%
5	75327	4.1%
Other values (10)	638053	35.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1819169	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	190214	10.5%
1	152695	8.4%
4	146798	8.1%
.	126162	6.9%
	126162	6.9%
7	118192	6.5%
6	87604	4.8%
3	82331	4.5%
8	75631	4.2%
5	75327	4.1%
Other values (10)	638053	35.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1819169	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	190214	10.5%
1	152695	8.4%
4	146798	8.1%
.	126162	6.9%
	126162	6.9%
7	118192	6.5%
6	87604	4.8%
3	82331	4.5%
8	75631	4.2%
5	75327	4.1%
Other values (10)	638053	35.1%

Electric Utility
Text

Distinct	68
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	985.6 KiB

Length

Max length	112
Median length	110
Mean length	44.689637
Min length	11

Characters and Unicode

Total characters	2819067
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	PUGET SOUND ENERGY INC
2nd row	PUGET SOUND ENERGY INC
3rd row	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF TACOMA - (WA)\|\|PENINSULA LIGHT COMPANY
4th row	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)
5th row	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF TACOMA - (WA)\|\|ELMHURST MUTUAL POWER & LIGHT CO\|PENINSULA LIGHT COMPANY

Value	Count	Frequency (%)
of	60958	12.8%
	56800	11.9%
wa	39022	8.2%
tacoma	38560	8.1%
sound	37313	7.8%
energy	37313	7.8%
puget	36925	7.7%
inc\|\|city	22547	4.7%
power	14116	3.0%
inc	12860	2.7%
Other values (101)	120907	25.3%

Most occurring characters

Value	Count	Frequency (%)
	414240	14.7%
O	208121	7.4%
N	199188	7.1%
T	197085	7.0%
A	191354	6.8%
E	183728	6.5%
I	152715	5.4%
C	152560	5.4%
Y	103205	3.7%
U	97696	3.5%
Other values (26)	919175	32.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2819067	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	414240	14.7%
O	208121	7.4%
N	199188	7.1%
T	197085	7.0%
A	191354	6.8%
E	183728	6.5%
I	152715	5.4%
C	152560	5.4%
Y	103205	3.7%
U	97696	3.5%
Other values (26)	919175	32.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2819067	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	414240	14.7%
O	208121	7.4%
N	199188	7.1%
T	197085	7.0%
A	191354	6.8%
E	183728	6.5%
I	152715	5.4%
C	152560	5.4%
Y	103205	3.7%
U	97696	3.5%
Other values (26)	919175	32.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2819067	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	414240	14.7%
O	208121	7.4%
N	199188	7.1%
T	197085	7.0%
A	191354	6.8%
E	183728	6.5%
I	152715	5.4%
C	152560	5.4%
Y	103205	3.7%
U	97696	3.5%
Other values (26)	919175	32.6%

Expected Price ($1k)
Real number (ℝ)

HIGH CORRELATION

Distinct	208
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45.476095

Minimum	0
Maximum	1100
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	985.6 KiB

Quantile statistics

Minimum	0
5-th percentile	16
Q1	22.857
median	40
Q3	67.07
95-th percentile	78
Maximum	1100
Range	1100
Interquartile range (IQR)	44.213

Descriptive statistics

Standard deviation	24.757155
Coefficient of variation (CV)	0.54439931
Kurtosis	73.314354
Mean	45.476095
Median Absolute Deviation (MAD)	20
Skewness	2.4993769
Sum	2868677.5
Variance	612.91671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69	4734	7.5%
73	4689	7.4%
64	3564	5.6%
57	2736	4.3%
50	2475	3.9%
25	2007	3.2%
18	1908	3.0%
20	1905	3.0%
19	1725	2.7%
72	1631	2.6%
Other values (198)	35707	56.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
2.8	2	< 0.1%
3	4	< 0.1%
5.499	50	0.1%
6.9	52	0.1%
7	124	0.2%
8.9	78	0.1%
9.035	74	0.1%
9.079	51	0.1%
10	19	< 0.1%

Value	Count	Frequency (%)
1100	1	< 0.1%
845	1	< 0.1%
600	1	< 0.1%
189	3	< 0.1%
142	321	0.5%
136.8	62	0.1%
124.9	14	< 0.1%
119.8	75	0.1%
117.4	10	< 0.1%
114.99	28	< 0.1%

Auto

Heatmap
Table

	Base MSRP	Clean Alternative Fuel Vehicle (CAFV) Eligibility	County	DOL Vehicle ID	Electric Range	Electric Vehicle Type	Expected Price ($1k)	Legislative District	Make	Model Year	State	ZIP Code
Base MSRP	1.000	0.024	0.000	0.026	0.032	0.024	-0.146	-0.004	0.249	-0.194	0.000	0.004
Clean Alternative Fuel Vehicle (CAFV) Eligibility	0.024	1.000	0.068	0.362	0.671	0.727	0.890	0.046	0.592	0.455	0.000	0.000
County	0.000	0.068	1.000	0.017	0.056	0.123	0.052	0.593	0.045	0.039	0.936	1.000
DOL Vehicle ID	0.026	0.362	0.017	1.000	-0.056	0.090	-0.062	-0.002	0.097	-0.148	0.006	-0.008
Electric Range	0.032	0.671	0.056	-0.056	1.000	0.633	0.016	0.035	0.450	-0.314	0.000	-0.050
Electric Vehicle Type	0.024	0.727	0.123	0.090	0.633	1.000	0.846	0.094	0.796	0.206	0.000	0.000
Expected Price ($1k)	-0.146	0.890	0.052	-0.062	0.016	0.846	1.000	0.074	0.814	0.621	0.000	-0.153
Legislative District	-0.004	0.046	0.593	-0.002	0.035	0.094	0.074	1.000	0.061	0.028	0.021	-0.356
Make	0.249	0.592	0.045	0.097	0.450	0.796	0.814	0.061	1.000	0.408	0.000	0.000
Model Year	-0.194	0.455	0.039	-0.148	-0.314	0.206	0.621	0.028	0.408	1.000	0.000	-0.073
State	0.000	0.000	0.936	0.006	0.000	0.000	0.000	0.021	0.000	0.000	1.000	1.000
ZIP Code	0.004	0.000	1.000	-0.008	-0.050	0.000	-0.153	-0.356	0.000	-0.073	1.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	ID	VIN (1-10)	County	City	State	ZIP Code	Model Year	Make	Model	Electric Vehicle Type	Clean Alternative Fuel Vehicle (CAFV) Eligibility	Electric Range	Base MSRP	Legislative District	DOL Vehicle ID	Vehicle Location	Electric Utility	Expected Price ($1k)
0	EV33174	5YJ3E1EC6L	Snohomish	LYNNWOOD	WA	98037.0	2020.0	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	308	0	32.0	109821694	POINT (-122.287614 47.83874)	PUGET SOUND ENERGY INC	50
1	EV40247	JN1AZ0CP8B	Skagit	BELLINGHAM	WA	98229.0	2011.0	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	73	0	40.0	137375528	POINT (-122.414936 48.709388)	PUGET SOUND ENERGY INC	15
2	EV12248	WBY1Z2C56F	Pierce	TACOMA	WA	98422.0	2015.0	BMW	I3	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	81	0	27.0	150627382	POINT (-122.396286 47.293138)	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF TACOMA - (WA)\|\|PENINSULA LIGHT COMPANY	18
3	EV55713	1G1RD6E44D	King	REDMOND	WA	98053.0	2013.0	CHEVROLET	VOLT	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	38	0	45.0	258766301	POINT (-122.024951 47.670286)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	33.9
4	EV28799	1G1FY6S05K	Pierce	PUYALLUP	WA	98375.0	2019.0	CHEVROLET	BOLT EV	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	238	0	25.0	296998138	POINT (-122.321062 47.103797)	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF TACOMA - (WA)\|\|ELMHURST MUTUAL POWER & LIGHT CO\|PENINSULA LIGHT COMPANY	41.78
5	EV49859	KMHE24L10G	Clark	VANCOUVER	WA	98683.0	2016.0	HYUNDAI	SONATA PLUG-IN HYBRID	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	27	34600	18.0	110121371	POINT (-122.510748 45.603727)	BONNEVILLE POWER ADMINISTRATION\|\|PUD NO 1 OF CLARK COUNTY - (WA)	16.365
7	EV53121	5YJSA1E22G	Spokane	SPOKANE	WA	99224.0	2016.0	TESLA	MODEL S	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	210	0	6.0	349565044	POINT (-117.505436 47.633834)	MODERN ELECTRIC WATER COMPANY	65
8	EV46881	1N4BZ0CP9H	King	BOTHELL	WA	98011.0	2017.0	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	107	0	1.0	327624048	POINT (-122.197147 47.757791)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	19
9	EV32004	1N4BZ0CP4G	King	KENMORE	WA	98028.0	2016.0	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	84	0	46.0	148960990	POINT (-122.246193 47.755504)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	27
10	EV54503	1N4AZ1CP9L	King	REDMOND	WA	98052.0	2020.0	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	149	0	45.0	132454822	POINT (-122.122018 47.678465)	PUGET SOUND ENERGY INC\|\|CITY OF TACOMA - (WA)	40

	ID	VIN (1-10)	County	City	State	ZIP Code	Model Year	Make	Model	Electric Vehicle Type	Clean Alternative Fuel Vehicle (CAFV) Eligibility	Electric Range	Legislative District	DOL Vehicle ID	Vehicle Location	Electric Utility	Expected Price ($1k)
64343	EV73428	2C4RC1S79N	Kitsap	BAINBRIDGE ISLAND	WA	98110.0	2022.0	CHRYSLER	PACIFICA	Plug-in Hybrid Electric Vehicle (PHEV)	Clean Alternative Fuel Vehicle Eligible	32	23.0	189998441	POINT (-122.534497 47.643688)	PUGET SOUND ENERGY INC	38
64344	EV1574	5YJYGDEF6M	King	SHORELINE	WA	98177.0	2021.0	TESLA	MODEL Y	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched	0	32.0	166439997	POINT (-122.370159 47.743354)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	73
64345	EV67089	5YJ3E1EA8N	King	SEATTLE	WA	98144.0	2022.0	TESLA	MODEL 3	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched	0	37.0	183477598	POINT (-122.30033 47.585339)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	64
64346	EV24820	YV4ED3UR6N	King	SEATTLE	WA	98116.0	2022.0	VOLVO	XC40	Battery Electric Vehicle (BEV)	Eligibility unknown as battery range has not been researched	0	34.0	186988966	POINT (-122.394511 47.574001)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	95
64347	EV46111	1N4AZ0CP9D	Kitsap	POULSBO	WA	98370.0	2013.0	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	75	23.0	263375976	POINT (-122.633393 47.748427)	PUGET SOUND ENERGY INC	18
64348	EV6357	KNDCE3LG7L	King	SEATTLE	WA	98144.0	2020.0	KIA	NIRO	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	239	37.0	156575107	POINT (-122.30033 47.585339)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	33
64349	EV423	JTDKN3DP2D	Pierce	TACOMA	WA	98402.0	2013.0	TOYOTA	PRIUS PLUG-IN	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	6	27.0	211048701	POINT (-122.443211 47.252172)	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF TACOMA - (WA)\|\|PENINSULA LIGHT COMPANY	13.3
64350	EV27852	1G1FX6S05J	King	SEATTLE	WA	98119.0	2018.0	CHEVROLET	BOLT EV	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	238	36.0	135543411	POINT (-122.367721 47.639264)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	22.857
64351	EV830	WP1AE2A24H	King	SEATTLE	WA	98115.0	2017.0	PORSCHE	CAYENNE	Plug-in Hybrid Electric Vehicle (PHEV)	Not eligible due to low battery range	14	46.0	192459907	POINT (-122.297534 47.685291)	CITY OF SEATTLE - (WA)\|CITY OF TACOMA - (WA)	45.7
64352	EV11120	1N4BZ1CP8K	Lewis	TOLEDO	WA	98591.0	2019.0	NISSAN	LEAF	Battery Electric Vehicle (BEV)	Clean Alternative Fuel Vehicle Eligible	150	20.0	477551595	POINT (-122.800917 46.444012)	BONNEVILLE POWER ADMINISTRATION\|\|CITY OF TACOMA - (WA)\|\|PUD NO 1 OF LEWIS COUNTY	35

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values